using System;
using System.Collections.Generic;
using System.Data;
using System.Data.SqlClient;

namespace Model
{
    /// <summary>
    /// 实体类FlightPassengerModel
    /// </summary>
    [Serializable]
    public class FlightPassengerModel
    {
        #region Field
        private Int32 _id = 0;
        private Int32 _orderid = 0;
        private Byte _ordertype = 0;
        private Byte _tickettype = 0;
        private Byte _segmenttype = 0;
        private DateTime _flyoffdate = new DateTime(1900, 1, 1);
        private DateTime _arrivaldate = new DateTime(1900, 1, 1);
        private string _startport = "";
        private string _endport = "";
        private string _airways = "";
        private string _flightno = "";
        private string _cabincode = "";
        private Byte _passengertype = 0;
        private string _countrycode = "";
        private string _passengername = "";
        private string _carriername = "";
        private Byte _certtype = 0;
        private string _certno = "";
        private Byte _gender = 0;
        private Int32 _systicketprice = 0;
        private Decimal _agreementticketprice = 0.0m;
        private Decimal _customerticketprice = 0.0m;
        private Int32 _buildfareprice = 0;
        private Int32 _taxfareprice = 0;
        private Int32 _insuranceunitprice = 0;
        private Int32 _thinsurancecost = 0;
        private Int32 _insurancegain = 0;
        private string _insuranceflag = "";
        private string _insurancepolicyno = "";
        private Int32 _insurancenum = 0;
        private Int32 _insurancerenum = 0;
        private Int32 _insuranceprice = 0;
        private string _eticketno = "";
        private string _ticketpnr = "";
        private Decimal _thprize = 0.0m;
        private string _ticketflag = "";
        private string _threceiptno = "";
        private Byte _isthprint = 0;
        private string _merchantreceiptno = "";
        private Byte _ismerchantprint = 0;
        private string _remark = "";
        private Int32 _disrate = 0;
        private string _basecabincode = "";
        private string _equipmentdes = "";
        private DateTime _outticketdate = new DateTime(1900, 1, 1);
        private Decimal _inputgain = 0.0m;
        private Decimal _remotebuykeeprebate = 0.0m;
        private Decimal _remotebuykeepprice = 0.0m;
        private string _billflag = "";
        private string _orderserialid = "";
        private Decimal _buyerpaymentrebate = 0.0m;
        private Decimal _buyerpaymentfee = 0.0m;
        private Decimal _salerpaymentrebate = 0.0m;
        private Decimal _salerpaymentfee = 0.0m;
        private Decimal _platformpaymentservicerebate = 0.0m;
        private Decimal _platformpaymentservicefee = 0.0m;
        private Decimal _platformcollectslottingrebate = 0.0m;
        private Decimal _platformcollectslottingfee = 0.0m;
        private Decimal _platformrecollectslottingfee = 0.0m;
        private Decimal _remotebuypaymentslottingfee = 0.0m;
        private Decimal _remotebuyrepaymentslottingfee = 0.0m;
        private Decimal _buyerrepaymentfee = 0.0m;
        private Decimal _salerrepaymentfee = 0.0m;
        private Decimal _pricerebate = 0.0m;
        private Decimal _dpprize = 0.0m;
        private Decimal _tckeaprebate = 0.0m;
        private Decimal _tcgain = 0.0m;
        private Byte _ischangepnr = 0;
        private Byte _iseticketused = 0;
        private Int32 _orgsysprice = 0;
        private Int32 _patsysprice = 0;
        private Int32 _newsysprice = 0;
        private string _guid = "";
        private Byte _checkedflag = 0;
        private string _bigcode = "";
        private Decimal _tripfee = 0.0m;
        private string _upgradeserialid = "";
        private Byte _issettlementunionprize = 0;
        private string _birthday = "";
        private Byte _ischanged = 0;
        private DateTime _lastflyoffdate = new DateTime(1900, 1, 1);
        private string _lastcabincode = "";
        private string _laststartport = "";
        private string _lastendport = "";
        private Byte _fpisnotprint = 0;
        private Byte _fphassended = 0;
        private Int32 _fpqqpassengerid = 0;
        private string _fpsaleretickets = "";
        private Decimal _fpusedcoupon = 0.0m;
        private Byte _fpinsurancetype = 0;
        private Decimal _fpybareprice = 0.0m;
        private Decimal _fpzbareprice = 0.0m;
        private string _fpriskcode = "";
        private Decimal _fptcshouldrefundticketfee = 0.0m;
        private Decimal _fpcustshouldpayrefundfee = 0.0m;
        private Decimal _fptcshouldrefundbuildfee = 0.0m;
        private Decimal _fptcshouldrefundtaxfare = 0.0m;
        private Decimal _fptcshouldrefundinsurancefee = 0.0m;
        private string _fpnewpnr = "";
        private Decimal _fpselfrealpay = 0.0m;
        private DateTime _fpselftradedate = new DateTime(1900, 1, 1);
        private string _fpselftradeno = "";
        private string _fpselfpaymenttype = "";
        private Int32 _fpselfrefstdid = 0;
        private Decimal _fpclearcustomerticketprice = 0.0m;
        private Decimal _fpcopcustomerticketprice = 0.0m;
        private Decimal _fpcopallinsurance = 0.0m;
        private string _fpcoppassengerid = "";
        private Int32 _fpcetsysticketprice = 0;
        private Int32 _fpcetbuildfareprice = 0;
        private Int32 _fpcettaxfareprice = 0;
        private Int32 _fpcbpttotaltax = 0;
        private Int32 _fpcbptpayprice = 0;
        private Decimal _fpcbptpolicy = 0.0m;
        private Int32 _fppubpassengerid = 0;
        private Decimal _fpforeprofit = 0.0m;
        private Int32 _fpplanetype = 0;
        private Int32 _fprefrouteinfoid = 0;
        private DateTime _fpcreatedate = new DateTime(1900, 1, 1);
        private string _fpcrafttype = "";
        private Byte _fprouteno = 0;
        private Decimal _fpsysrawticketprice = 0.0m;
        #endregion Field

        #region Construct
        public FlightPassengerModel()
        { }
        public FlightPassengerModel(DataRow row)
        {
            if (Convert.IsDBNull(row["Id"]))
                Id = 0;
            else
                Id = Int32.Parse(row["Id"].ToString());
            if (Convert.IsDBNull(row["OrderId"]))
                OrderId = 0;
            else
                OrderId = Int32.Parse(row["OrderId"].ToString());
            if (Convert.IsDBNull(row["OrderType"]))
                OrderType = 0;
            else
                OrderType = Byte.Parse(row["OrderType"].ToString());
            if (Convert.IsDBNull(row["TicketType"]))
                TicketType = 0;
            else
                TicketType = Byte.Parse(row["TicketType"].ToString());
            if (Convert.IsDBNull(row["SegmentType"]))
                SegmentType = 0;
            else
                SegmentType = Byte.Parse(row["SegmentType"].ToString());
            if (Convert.IsDBNull(row["FlyOffDate"]))
                FlyOffDate = new DateTime(1900, 1, 1);
            else
                FlyOffDate = DateTime.Parse(row["FlyOffDate"].ToString());
            if (Convert.IsDBNull(row["ArrivalDate"]))
                ArrivalDate = new DateTime(1900, 1, 1);
            else
                ArrivalDate = DateTime.Parse(row["ArrivalDate"].ToString());
            StartPort = row["StartPort"].ToString();
            EndPort = row["EndPort"].ToString();
            Airways = row["Airways"].ToString();
            FlightNO = row["FlightNO"].ToString();
            CabinCode = row["CabinCode"].ToString();
            if (Convert.IsDBNull(row["PassengerType"]))
                PassengerType = 0;
            else
                PassengerType = Byte.Parse(row["PassengerType"].ToString());
            CountryCode = row["CountryCode"].ToString();
            PassengerName = row["PassengerName"].ToString();
            CarrierName = row["CarrierName"].ToString();
            if (Convert.IsDBNull(row["CertType"]))
                CertType = 0;
            else
                CertType = Byte.Parse(row["CertType"].ToString());
            CertNO = row["CertNO"].ToString();
            if (Convert.IsDBNull(row["Gender"]))
                Gender = 0;
            else
                Gender = Byte.Parse(row["Gender"].ToString());
            if (Convert.IsDBNull(row["SysTicketPrice"]))
                SysTicketPrice = 0;
            else
                SysTicketPrice = Int32.Parse(row["SysTicketPrice"].ToString());
            if (Convert.IsDBNull(row["AgreementTicketPrice"]))
                AgreementTicketPrice = 0.0m;
            else
                AgreementTicketPrice = Decimal.Parse(row["AgreementTicketPrice"].ToString());
            if (Convert.IsDBNull(row["CustomerTicketPrice"]))
                CustomerTicketPrice = 0.0m;
            else
                CustomerTicketPrice = Decimal.Parse(row["CustomerTicketPrice"].ToString());
            if (Convert.IsDBNull(row["BuildFarePrice"]))
                BuildFarePrice = 0;
            else
                BuildFarePrice = Int32.Parse(row["BuildFarePrice"].ToString());
            if (Convert.IsDBNull(row["TaxFarePrice"]))
                TaxFarePrice = 0;
            else
                TaxFarePrice = Int32.Parse(row["TaxFarePrice"].ToString());
            if (Convert.IsDBNull(row["InsuranceUnitPrice"]))
                InsuranceUnitPrice = 0;
            else
                InsuranceUnitPrice = Int32.Parse(row["InsuranceUnitPrice"].ToString());
            if (Convert.IsDBNull(row["THInsuranceCost"]))
                THInsuranceCost = 0;
            else
                THInsuranceCost = Int32.Parse(row["THInsuranceCost"].ToString());
            if (Convert.IsDBNull(row["InsuranceGain"]))
                InsuranceGain = 0;
            else
                InsuranceGain = Int32.Parse(row["InsuranceGain"].ToString());
            InsuranceFlag = row["InsuranceFlag"].ToString();
            InsurancePolicyNO = row["InsurancePolicyNO"].ToString();
            if (Convert.IsDBNull(row["InsuranceNum"]))
                InsuranceNum = 0;
            else
                InsuranceNum = Int32.Parse(row["InsuranceNum"].ToString());
            if (Convert.IsDBNull(row["InsuranceReNum"]))
                InsuranceReNum = 0;
            else
                InsuranceReNum = Int32.Parse(row["InsuranceReNum"].ToString());
            if (Convert.IsDBNull(row["InsurancePrice"]))
                InsurancePrice = 0;
            else
                InsurancePrice = Int32.Parse(row["InsurancePrice"].ToString());
            ETicketNO = row["ETicketNO"].ToString();
            TicketPNR = row["TicketPNR"].ToString();
            if (Convert.IsDBNull(row["THPrize"]))
                THPrize = 0.0m;
            else
                THPrize = Decimal.Parse(row["THPrize"].ToString());
            TicketFlag = row["TicketFlag"].ToString();
            THReceiptNO = row["THReceiptNO"].ToString();
            if (Convert.IsDBNull(row["IsTHPrint"]))
                IsTHPrint = 0;
            else
                IsTHPrint = Byte.Parse(row["IsTHPrint"].ToString());
            MerchantReceiptNO = row["MerchantReceiptNO"].ToString();
            if (Convert.IsDBNull(row["IsMerchantPrint"]))
                IsMerchantPrint = 0;
            else
                IsMerchantPrint = Byte.Parse(row["IsMerchantPrint"].ToString());
            Remark = row["Remark"].ToString();
            if (Convert.IsDBNull(row["DisRate"]))
                DisRate = 0;
            else
                DisRate = Int32.Parse(row["DisRate"].ToString());
            BaseCabinCode = row["BaseCabinCode"].ToString();
            EquipmentDes = row["EquipmentDes"].ToString();
            if (Convert.IsDBNull(row["OutTicketDate"]))
                OutTicketDate = new DateTime(1900, 1, 1);
            else
                OutTicketDate = DateTime.Parse(row["OutTicketDate"].ToString());
            if (Convert.IsDBNull(row["InputGain"]))
                InputGain = 0.0m;
            else
                InputGain = Decimal.Parse(row["InputGain"].ToString());
            if (Convert.IsDBNull(row["RemoteBuyKeepRebate"]))
                RemoteBuyKeepRebate = 0.0m;
            else
                RemoteBuyKeepRebate = Decimal.Parse(row["RemoteBuyKeepRebate"].ToString());
            if (Convert.IsDBNull(row["RemoteBuyKeepPrice"]))
                RemoteBuyKeepPrice = 0.0m;
            else
                RemoteBuyKeepPrice = Decimal.Parse(row["RemoteBuyKeepPrice"].ToString());
            BillFlag = row["BillFlag"].ToString();
            OrderSerialid = row["OrderSerialid"].ToString();
            if (Convert.IsDBNull(row["BuyerPaymentRebate"]))
                BuyerPaymentRebate = 0.0m;
            else
                BuyerPaymentRebate = Decimal.Parse(row["BuyerPaymentRebate"].ToString());
            if (Convert.IsDBNull(row["BuyerPaymentFee"]))
                BuyerPaymentFee = 0.0m;
            else
                BuyerPaymentFee = Decimal.Parse(row["BuyerPaymentFee"].ToString());
            if (Convert.IsDBNull(row["SalerPaymentRebate"]))
                SalerPaymentRebate = 0.0m;
            else
                SalerPaymentRebate = Decimal.Parse(row["SalerPaymentRebate"].ToString());
            if (Convert.IsDBNull(row["SalerPaymentFee"]))
                SalerPaymentFee = 0.0m;
            else
                SalerPaymentFee = Decimal.Parse(row["SalerPaymentFee"].ToString());
            if (Convert.IsDBNull(row["PlatformPaymentServiceRebate"]))
                PlatformPaymentServiceRebate = 0.0m;
            else
                PlatformPaymentServiceRebate = Decimal.Parse(row["PlatformPaymentServiceRebate"].ToString());
            if (Convert.IsDBNull(row["PlatformPaymentServiceFee"]))
                PlatformPaymentServiceFee = 0.0m;
            else
                PlatformPaymentServiceFee = Decimal.Parse(row["PlatformPaymentServiceFee"].ToString());
            if (Convert.IsDBNull(row["PlatformCollectSlottingRebate"]))
                PlatformCollectSlottingRebate = 0.0m;
            else
                PlatformCollectSlottingRebate = Decimal.Parse(row["PlatformCollectSlottingRebate"].ToString());
            if (Convert.IsDBNull(row["PlatformCollectSlottingFee"]))
                PlatformCollectSlottingFee = 0.0m;
            else
                PlatformCollectSlottingFee = Decimal.Parse(row["PlatformCollectSlottingFee"].ToString());
            if (Convert.IsDBNull(row["PlatformReCollectSlottingFee"]))
                PlatformReCollectSlottingFee = 0.0m;
            else
                PlatformReCollectSlottingFee = Decimal.Parse(row["PlatformReCollectSlottingFee"].ToString());
            if (Convert.IsDBNull(row["RemoteBuyPaymentSlottingFee"]))
                RemoteBuyPaymentSlottingFee = 0.0m;
            else
                RemoteBuyPaymentSlottingFee = Decimal.Parse(row["RemoteBuyPaymentSlottingFee"].ToString());
            if (Convert.IsDBNull(row["RemoteBuyRePaymentSlottingFee"]))
                RemoteBuyRePaymentSlottingFee = 0.0m;
            else
                RemoteBuyRePaymentSlottingFee = Decimal.Parse(row["RemoteBuyRePaymentSlottingFee"].ToString());
            if (Convert.IsDBNull(row["BuyerRePaymentFee"]))
                BuyerRePaymentFee = 0.0m;
            else
                BuyerRePaymentFee = Decimal.Parse(row["BuyerRePaymentFee"].ToString());
            if (Convert.IsDBNull(row["SalerRePaymentFee"]))
                SalerRePaymentFee = 0.0m;
            else
                SalerRePaymentFee = Decimal.Parse(row["SalerRePaymentFee"].ToString());
            if (Convert.IsDBNull(row["PriceRebate"]))
                PriceRebate = 0.0m;
            else
                PriceRebate = Decimal.Parse(row["PriceRebate"].ToString());
            if (Convert.IsDBNull(row["DPPrize"]))
                DPPrize = 0.0m;
            else
                DPPrize = Decimal.Parse(row["DPPrize"].ToString());
            if (Convert.IsDBNull(row["TCKeapRebate"]))
                TCKeapRebate = 0.0m;
            else
                TCKeapRebate = Decimal.Parse(row["TCKeapRebate"].ToString());
            if (Convert.IsDBNull(row["TCGain"]))
                TCGain = 0.0m;
            else
                TCGain = Decimal.Parse(row["TCGain"].ToString());
            if (Convert.IsDBNull(row["IsChangePNR"]))
                IsChangePNR = 0;
            else
                IsChangePNR = Byte.Parse(row["IsChangePNR"].ToString());
            if (Convert.IsDBNull(row["IsETicketUsed"]))
                IsETicketUsed = 0;
            else
                IsETicketUsed = Byte.Parse(row["IsETicketUsed"].ToString());
            if (Convert.IsDBNull(row["OrgSysPrice"]))
                OrgSysPrice = 0;
            else
                OrgSysPrice = Int32.Parse(row["OrgSysPrice"].ToString());
            if (Convert.IsDBNull(row["PatSysPrice"]))
                PatSysPrice = 0;
            else
                PatSysPrice = Int32.Parse(row["PatSysPrice"].ToString());
            if (Convert.IsDBNull(row["NewSysPrice"]))
                NewSysPrice = 0;
            else
                NewSysPrice = Int32.Parse(row["NewSysPrice"].ToString());
            Guid = row["Guid"].ToString();
            if (Convert.IsDBNull(row["CheckedFlag"]))
                CheckedFlag = 0;
            else
                CheckedFlag = Byte.Parse(row["CheckedFlag"].ToString());
            BigCode = row["BigCode"].ToString();
            if (Convert.IsDBNull(row["TripFee"]))
                TripFee = 0.0m;
            else
                TripFee = Decimal.Parse(row["TripFee"].ToString());
            UpgradeSerialId = row["UpgradeSerialId"].ToString();
            if (Convert.IsDBNull(row["IsSettlementUnionPrize"]))
                IsSettlementUnionPrize = 0;
            else
                IsSettlementUnionPrize = Byte.Parse(row["IsSettlementUnionPrize"].ToString());
            BirthDay = row["BirthDay"].ToString();
            if (Convert.IsDBNull(row["IsChanged"]))
                IsChanged = 0;
            else
                IsChanged = Byte.Parse(row["IsChanged"].ToString());
            if (Convert.IsDBNull(row["LastFlyOffDate"]))
                LastFlyOffDate = new DateTime(1900, 1, 1);
            else
                LastFlyOffDate = DateTime.Parse(row["LastFlyOffDate"].ToString());
            LastCabinCode = row["LastCabinCode"].ToString();
            LastStartPort = row["LastStartPort"].ToString();
            LastEndPort = row["LastEndPort"].ToString();
            if (Convert.IsDBNull(row["FPIsNotPrint"]))
                FPIsNotPrint = 0;
            else
                FPIsNotPrint = Byte.Parse(row["FPIsNotPrint"].ToString());
            if (Convert.IsDBNull(row["FPHasSended"]))
                FPHasSended = 0;
            else
                FPHasSended = Byte.Parse(row["FPHasSended"].ToString());
            if (Convert.IsDBNull(row["FPQQPassengerId"]))
                FPQQPassengerId = 0;
            else
                FPQQPassengerId = Int32.Parse(row["FPQQPassengerId"].ToString());
            FPSalerEtickets = row["FPSalerEtickets"].ToString();
            if (Convert.IsDBNull(row["FPUsedCoupon"]))
                FPUsedCoupon = 0.0m;
            else
                FPUsedCoupon = Decimal.Parse(row["FPUsedCoupon"].ToString());
            if (Convert.IsDBNull(row["FPInsuranceType"]))
                FPInsuranceType = 0;
            else
                FPInsuranceType = Byte.Parse(row["FPInsuranceType"].ToString());
            if (Convert.IsDBNull(row["FPYBarePrice"]))
                FPYBarePrice = 0.0m;
            else
                FPYBarePrice = Decimal.Parse(row["FPYBarePrice"].ToString());
            if (Convert.IsDBNull(row["FPZBarePrice"]))
                FPZBarePrice = 0.0m;
            else
                FPZBarePrice = Decimal.Parse(row["FPZBarePrice"].ToString());
            FPRiskCode = row["FPRiskCode"].ToString();
            if (Convert.IsDBNull(row["FPTcShouldRefundTicketFee"]))
                FPTcShouldRefundTicketFee = 0.0m;
            else
                FPTcShouldRefundTicketFee = Decimal.Parse(row["FPTcShouldRefundTicketFee"].ToString());
            if (Convert.IsDBNull(row["FPCustShouldPayRefundFee"]))
                FPCustShouldPayRefundFee = 0.0m;
            else
                FPCustShouldPayRefundFee = Decimal.Parse(row["FPCustShouldPayRefundFee"].ToString());
            if (Convert.IsDBNull(row["FPTcShouldRefundBuildFee"]))
                FPTcShouldRefundBuildFee = 0.0m;
            else
                FPTcShouldRefundBuildFee = Decimal.Parse(row["FPTcShouldRefundBuildFee"].ToString());
            if (Convert.IsDBNull(row["FPTcShouldRefundTaxFare"]))
                FPTcShouldRefundTaxFare = 0.0m;
            else
                FPTcShouldRefundTaxFare = Decimal.Parse(row["FPTcShouldRefundTaxFare"].ToString());
            if (Convert.IsDBNull(row["FPTcShouldRefundInsuranceFee"]))
                FPTcShouldRefundInsuranceFee = 0.0m;
            else
                FPTcShouldRefundInsuranceFee = Decimal.Parse(row["FPTcShouldRefundInsuranceFee"].ToString());
            FPNewPNR = row["FPNewPNR"].ToString();
            if (Convert.IsDBNull(row["FPSelfRealPay"]))
                FPSelfRealPay = 0.0m;
            else
                FPSelfRealPay = Decimal.Parse(row["FPSelfRealPay"].ToString());
            if (Convert.IsDBNull(row["FPSelfTradeDate"]))
                FPSelfTradeDate = new DateTime(1900, 1, 1);
            else
                FPSelfTradeDate = DateTime.Parse(row["FPSelfTradeDate"].ToString());
            FPSelfTradeNo = row["FPSelfTradeNo"].ToString();
            FPSelfPaymentType = row["FPSelfPaymentType"].ToString();
            if (Convert.IsDBNull(row["FPSelfRefSTDId"]))
                FPSelfRefSTDId = 0;
            else
                FPSelfRefSTDId = Int32.Parse(row["FPSelfRefSTDId"].ToString());
            if (Convert.IsDBNull(row["FPClearCustomerTicketPrice"]))
                FPClearCustomerTicketPrice = 0.0m;
            else
                FPClearCustomerTicketPrice = Decimal.Parse(row["FPClearCustomerTicketPrice"].ToString());
            if (Convert.IsDBNull(row["FPCopCustomerTicketPrice"]))
                FPCopCustomerTicketPrice = 0.0m;
            else
                FPCopCustomerTicketPrice = Decimal.Parse(row["FPCopCustomerTicketPrice"].ToString());
            if (Convert.IsDBNull(row["FPCopAllInsurance"]))
                FPCopAllInsurance = 0.0m;
            else
                FPCopAllInsurance = Decimal.Parse(row["FPCopAllInsurance"].ToString());
            FPCopPassengerId = row["FPCopPassengerId"].ToString();
            if (Convert.IsDBNull(row["FPCETSysTicketPrice"]))
                FPCETSysTicketPrice = 0;
            else
                FPCETSysTicketPrice = Int32.Parse(row["FPCETSysTicketPrice"].ToString());
            if (Convert.IsDBNull(row["FPCETBuildFarePrice"]))
                FPCETBuildFarePrice = 0;
            else
                FPCETBuildFarePrice = Int32.Parse(row["FPCETBuildFarePrice"].ToString());
            if (Convert.IsDBNull(row["FPCETTaxFarePrice"]))
                FPCETTaxFarePrice = 0;
            else
                FPCETTaxFarePrice = Int32.Parse(row["FPCETTaxFarePrice"].ToString());
            if (Convert.IsDBNull(row["FPCBPTTotaltax"]))
                FPCBPTTotaltax = 0;
            else
                FPCBPTTotaltax = Int32.Parse(row["FPCBPTTotaltax"].ToString());
            if (Convert.IsDBNull(row["FPCBPTPayprice"]))
                FPCBPTPayprice = 0;
            else
                FPCBPTPayprice = Int32.Parse(row["FPCBPTPayprice"].ToString());
            if (Convert.IsDBNull(row["FPCBPTPolicy"]))
                FPCBPTPolicy = 0.0m;
            else
                FPCBPTPolicy = Decimal.Parse(row["FPCBPTPolicy"].ToString());
            if (Convert.IsDBNull(row["FPPubPassengerId"]))
                FPPubPassengerId = 0;
            else
                FPPubPassengerId = Int32.Parse(row["FPPubPassengerId"].ToString());
            if (Convert.IsDBNull(row["FPForeProfit"]))
                FPForeProfit = 0.0m;
            else
                FPForeProfit = Decimal.Parse(row["FPForeProfit"].ToString());
            if (Convert.IsDBNull(row["FPPlaneType"]))
                FPPlaneType = 0;
            else
                FPPlaneType = Int32.Parse(row["FPPlaneType"].ToString());
            if (Convert.IsDBNull(row["FPRefRouteInfoId"]))
                FPRefRouteInfoId = 0;
            else
                FPRefRouteInfoId = Int32.Parse(row["FPRefRouteInfoId"].ToString());
            if (Convert.IsDBNull(row["FPCreateDate"]))
                FPCreateDate = new DateTime(1900, 1, 1);
            else
                FPCreateDate = DateTime.Parse(row["FPCreateDate"].ToString());
            FPCraftType = row["FPCraftType"].ToString();
            if (Convert.IsDBNull(row["FPRouteNo"]))
                FPRouteNo = 0;
            else
                FPRouteNo = Byte.Parse(row["FPRouteNo"].ToString());
            if (Convert.IsDBNull(row["FPSysRawTicketPrice"]))
                FPSysRawTicketPrice = 0.0m;
            else
                FPSysRawTicketPrice = Decimal.Parse(row["FPSysRawTicketPrice"].ToString());
        }
        #endregion Construct

        #region Property
        /// <summary>
        /// Id
        /// </summary>
        public Int32 Id
        {
            set { _id = value; }
            get { return _id; }
        }
        /// <summary>
        /// OrderId
        /// </summary>
        public Int32 OrderId
        {
            set { _orderid = value; }
            get { return _orderid; }
        }
        /// <summary>
        /// OrderType
        /// </summary>
        public Byte OrderType
        {
            set { _ordertype = value; }
            get { return _ordertype; }
        }
        /// <summary>
        /// TicketType
        /// </summary>
        public Byte TicketType
        {
            set { _tickettype = value; }
            get { return _tickettype; }
        }
        /// <summary>
        /// SegmentType
        /// </summary>
        public Byte SegmentType
        {
            set { _segmenttype = value; }
            get { return _segmenttype; }
        }
        /// <summary>
        /// FlyOffDate
        /// </summary>
        public DateTime FlyOffDate
        {
            set { _flyoffdate = value; }
            get { return _flyoffdate; }
        }
        /// <summary>
        /// ArrivalDate
        /// </summary>
        public DateTime ArrivalDate
        {
            set { _arrivaldate = value; }
            get { return _arrivaldate; }
        }
        /// <summary>
        /// StartPort
        /// </summary>
        public string StartPort
        {
            set { _startport = value; }
            get { return _startport; }
        }
        /// <summary>
        /// EndPort
        /// </summary>
        public string EndPort
        {
            set { _endport = value; }
            get { return _endport; }
        }
        /// <summary>
        /// Airways
        /// </summary>
        public string Airways
        {
            set { _airways = value; }
            get { return _airways; }
        }
        /// <summary>
        /// FlightNO
        /// </summary>
        public string FlightNO
        {
            set { _flightno = value; }
            get { return _flightno; }
        }
        /// <summary>
        /// CabinCode
        /// </summary>
        public string CabinCode
        {
            set { _cabincode = value; }
            get { return _cabincode; }
        }
        /// <summary>
        /// PassengerType
        /// </summary>
        public Byte PassengerType
        {
            set { _passengertype = value; }
            get { return _passengertype; }
        }
        /// <summary>
        /// CountryCode
        /// </summary>
        public string CountryCode
        {
            set { _countrycode = value; }
            get { return _countrycode; }
        }
        /// <summary>
        /// PassengerName
        /// </summary>
        public string PassengerName
        {
            set { _passengername = value; }
            get { return _passengername; }
        }
        /// <summary>
        /// CarrierName
        /// </summary>
        public string CarrierName
        {
            set { _carriername = value; }
            get { return _carriername; }
        }
        /// <summary>
        /// CertType
        /// </summary>
        public Byte CertType
        {
            set { _certtype = value; }
            get { return _certtype; }
        }
        /// <summary>
        /// CertNO
        /// </summary>
        public string CertNO
        {
            set { _certno = value; }
            get { return _certno; }
        }
        /// <summary>
        /// Gender
        /// </summary>
        public Byte Gender
        {
            set { _gender = value; }
            get { return _gender; }
        }
        /// <summary>
        /// SysTicketPrice
        /// </summary>
        public Int32 SysTicketPrice
        {
            set { _systicketprice = value; }
            get { return _systicketprice; }
        }
        /// <summary>
        /// AgreementTicketPrice
        /// </summary>
        public Decimal AgreementTicketPrice
        {
            set { _agreementticketprice = value; }
            get { return _agreementticketprice; }
        }
        /// <summary>
        /// CustomerTicketPrice
        /// </summary>
        public Decimal CustomerTicketPrice
        {
            set { _customerticketprice = value; }
            get { return _customerticketprice; }
        }
        /// <summary>
        /// BuildFarePrice
        /// </summary>
        public Int32 BuildFarePrice
        {
            set { _buildfareprice = value; }
            get { return _buildfareprice; }
        }
        /// <summary>
        /// TaxFarePrice
        /// </summary>
        public Int32 TaxFarePrice
        {
            set { _taxfareprice = value; }
            get { return _taxfareprice; }
        }
        /// <summary>
        /// InsuranceUnitPrice
        /// </summary>
        public Int32 InsuranceUnitPrice
        {
            set { _insuranceunitprice = value; }
            get { return _insuranceunitprice; }
        }
        /// <summary>
        /// THInsuranceCost
        /// </summary>
        public Int32 THInsuranceCost
        {
            set { _thinsurancecost = value; }
            get { return _thinsurancecost; }
        }
        /// <summary>
        /// InsuranceGain
        /// </summary>
        public Int32 InsuranceGain
        {
            set { _insurancegain = value; }
            get { return _insurancegain; }
        }
        /// <summary>
        /// InsuranceFlag
        /// </summary>
        public string InsuranceFlag
        {
            set { _insuranceflag = value; }
            get { return _insuranceflag; }
        }
        /// <summary>
        /// InsurancePolicyNO
        /// </summary>
        public string InsurancePolicyNO
        {
            set { _insurancepolicyno = value; }
            get { return _insurancepolicyno; }
        }
        /// <summary>
        /// InsuranceNum
        /// </summary>
        public Int32 InsuranceNum
        {
            set { _insurancenum = value; }
            get { return _insurancenum; }
        }
        /// <summary>
        /// InsuranceReNum
        /// </summary>
        public Int32 InsuranceReNum
        {
            set { _insurancerenum = value; }
            get { return _insurancerenum; }
        }
        /// <summary>
        /// InsurancePrice
        /// </summary>
        public Int32 InsurancePrice
        {
            set { _insuranceprice = value; }
            get { return _insuranceprice; }
        }
        /// <summary>
        /// ETicketNO
        /// </summary>
        public string ETicketNO
        {
            set { _eticketno = value; }
            get { return _eticketno; }
        }
        /// <summary>
        /// TicketPNR
        /// </summary>
        public string TicketPNR
        {
            set { _ticketpnr = value; }
            get { return _ticketpnr; }
        }
        /// <summary>
        /// THPrize
        /// </summary>
        public Decimal THPrize
        {
            set { _thprize = value; }
            get { return _thprize; }
        }
        /// <summary>
        /// TicketFlag
        /// </summary>
        public string TicketFlag
        {
            set { _ticketflag = value; }
            get { return _ticketflag; }
        }
        /// <summary>
        /// THReceiptNO
        /// </summary>
        public string THReceiptNO
        {
            set { _threceiptno = value; }
            get { return _threceiptno; }
        }
        /// <summary>
        /// IsTHPrint
        /// </summary>
        public Byte IsTHPrint
        {
            set { _isthprint = value; }
            get { return _isthprint; }
        }
        /// <summary>
        /// MerchantReceiptNO
        /// </summary>
        public string MerchantReceiptNO
        {
            set { _merchantreceiptno = value; }
            get { return _merchantreceiptno; }
        }
        /// <summary>
        /// IsMerchantPrint
        /// </summary>
        public Byte IsMerchantPrint
        {
            set { _ismerchantprint = value; }
            get { return _ismerchantprint; }
        }
        /// <summary>
        /// Remark
        /// </summary>
        public string Remark
        {
            set { _remark = value; }
            get { return _remark; }
        }
        /// <summary>
        /// DisRate
        /// </summary>
        public Int32 DisRate
        {
            set { _disrate = value; }
            get { return _disrate; }
        }
        /// <summary>
        /// BaseCabinCode
        /// </summary>
        public string BaseCabinCode
        {
            set { _basecabincode = value; }
            get { return _basecabincode; }
        }
        /// <summary>
        /// EquipmentDes
        /// </summary>
        public string EquipmentDes
        {
            set { _equipmentdes = value; }
            get { return _equipmentdes; }
        }
        /// <summary>
        /// OutTicketDate
        /// </summary>
        public DateTime OutTicketDate
        {
            set { _outticketdate = value; }
            get { return _outticketdate; }
        }
        /// <summary>
        /// InputGain
        /// </summary>
        public Decimal InputGain
        {
            set { _inputgain = value; }
            get { return _inputgain; }
        }
        /// <summary>
        /// RemoteBuyKeepRebate
        /// </summary>
        public Decimal RemoteBuyKeepRebate
        {
            set { _remotebuykeeprebate = value; }
            get { return _remotebuykeeprebate; }
        }
        /// <summary>
        /// RemoteBuyKeepPrice
        /// </summary>
        public Decimal RemoteBuyKeepPrice
        {
            set { _remotebuykeepprice = value; }
            get { return _remotebuykeepprice; }
        }
        /// <summary>
        /// BillFlag
        /// </summary>
        public string BillFlag
        {
            set { _billflag = value; }
            get { return _billflag; }
        }
        /// <summary>
        /// OrderSerialid
        /// </summary>
        public string OrderSerialid
        {
            set { _orderserialid = value; }
            get { return _orderserialid; }
        }
        /// <summary>
        /// BuyerPaymentRebate
        /// </summary>
        public Decimal BuyerPaymentRebate
        {
            set { _buyerpaymentrebate = value; }
            get { return _buyerpaymentrebate; }
        }
        /// <summary>
        /// BuyerPaymentFee
        /// </summary>
        public Decimal BuyerPaymentFee
        {
            set { _buyerpaymentfee = value; }
            get { return _buyerpaymentfee; }
        }
        /// <summary>
        /// SalerPaymentRebate
        /// </summary>
        public Decimal SalerPaymentRebate
        {
            set { _salerpaymentrebate = value; }
            get { return _salerpaymentrebate; }
        }
        /// <summary>
        /// SalerPaymentFee
        /// </summary>
        public Decimal SalerPaymentFee
        {
            set { _salerpaymentfee = value; }
            get { return _salerpaymentfee; }
        }
        /// <summary>
        /// PlatformPaymentServiceRebate
        /// </summary>
        public Decimal PlatformPaymentServiceRebate
        {
            set { _platformpaymentservicerebate = value; }
            get { return _platformpaymentservicerebate; }
        }
        /// <summary>
        /// PlatformPaymentServiceFee
        /// </summary>
        public Decimal PlatformPaymentServiceFee
        {
            set { _platformpaymentservicefee = value; }
            get { return _platformpaymentservicefee; }
        }
        /// <summary>
        /// PlatformCollectSlottingRebate
        /// </summary>
        public Decimal PlatformCollectSlottingRebate
        {
            set { _platformcollectslottingrebate = value; }
            get { return _platformcollectslottingrebate; }
        }
        /// <summary>
        /// PlatformCollectSlottingFee
        /// </summary>
        public Decimal PlatformCollectSlottingFee
        {
            set { _platformcollectslottingfee = value; }
            get { return _platformcollectslottingfee; }
        }
        /// <summary>
        /// PlatformReCollectSlottingFee
        /// </summary>
        public Decimal PlatformReCollectSlottingFee
        {
            set { _platformrecollectslottingfee = value; }
            get { return _platformrecollectslottingfee; }
        }
        /// <summary>
        /// RemoteBuyPaymentSlottingFee
        /// </summary>
        public Decimal RemoteBuyPaymentSlottingFee
        {
            set { _remotebuypaymentslottingfee = value; }
            get { return _remotebuypaymentslottingfee; }
        }
        /// <summary>
        /// RemoteBuyRePaymentSlottingFee
        /// </summary>
        public Decimal RemoteBuyRePaymentSlottingFee
        {
            set { _remotebuyrepaymentslottingfee = value; }
            get { return _remotebuyrepaymentslottingfee; }
        }
        /// <summary>
        /// BuyerRePaymentFee
        /// </summary>
        public Decimal BuyerRePaymentFee
        {
            set { _buyerrepaymentfee = value; }
            get { return _buyerrepaymentfee; }
        }
        /// <summary>
        /// SalerRePaymentFee
        /// </summary>
        public Decimal SalerRePaymentFee
        {
            set { _salerrepaymentfee = value; }
            get { return _salerrepaymentfee; }
        }
        /// <summary>
        /// PriceRebate
        /// </summary>
        public Decimal PriceRebate
        {
            set { _pricerebate = value; }
            get { return _pricerebate; }
        }
        /// <summary>
        /// DPPrize
        /// </summary>
        public Decimal DPPrize
        {
            set { _dpprize = value; }
            get { return _dpprize; }
        }
        /// <summary>
        /// TCKeapRebate
        /// </summary>
        public Decimal TCKeapRebate
        {
            set { _tckeaprebate = value; }
            get { return _tckeaprebate; }
        }
        /// <summary>
        /// TCGain
        /// </summary>
        public Decimal TCGain
        {
            set { _tcgain = value; }
            get { return _tcgain; }
        }
        /// <summary>
        /// IsChangePNR
        /// </summary>
        public Byte IsChangePNR
        {
            set { _ischangepnr = value; }
            get { return _ischangepnr; }
        }
        /// <summary>
        /// IsETicketUsed
        /// </summary>
        public Byte IsETicketUsed
        {
            set { _iseticketused = value; }
            get { return _iseticketused; }
        }
        /// <summary>
        /// OrgSysPrice
        /// </summary>
        public Int32 OrgSysPrice
        {
            set { _orgsysprice = value; }
            get { return _orgsysprice; }
        }
        /// <summary>
        /// PatSysPrice
        /// </summary>
        public Int32 PatSysPrice
        {
            set { _patsysprice = value; }
            get { return _patsysprice; }
        }
        /// <summary>
        /// NewSysPrice
        /// </summary>
        public Int32 NewSysPrice
        {
            set { _newsysprice = value; }
            get { return _newsysprice; }
        }
        /// <summary>
        /// Guid
        /// </summary>
        public string Guid
        {
            set { _guid = value; }
            get { return _guid; }
        }
        /// <summary>
        /// CheckedFlag
        /// </summary>
        public Byte CheckedFlag
        {
            set { _checkedflag = value; }
            get { return _checkedflag; }
        }
        /// <summary>
        /// BigCode
        /// </summary>
        public string BigCode
        {
            set { _bigcode = value; }
            get { return _bigcode; }
        }
        /// <summary>
        /// TripFee
        /// </summary>
        public Decimal TripFee
        {
            set { _tripfee = value; }
            get { return _tripfee; }
        }
        /// <summary>
        /// UpgradeSerialId
        /// </summary>
        public string UpgradeSerialId
        {
            set { _upgradeserialid = value; }
            get { return _upgradeserialid; }
        }
        /// <summary>
        /// IsSettlementUnionPrize
        /// </summary>
        public Byte IsSettlementUnionPrize
        {
            set { _issettlementunionprize = value; }
            get { return _issettlementunionprize; }
        }
        /// <summary>
        /// BirthDay
        /// </summary>
        public string BirthDay
        {
            set { _birthday = value; }
            get { return _birthday; }
        }
        /// <summary>
        /// IsChanged
        /// </summary>
        public Byte IsChanged
        {
            set { _ischanged = value; }
            get { return _ischanged; }
        }
        /// <summary>
        /// LastFlyOffDate
        /// </summary>
        public DateTime LastFlyOffDate
        {
            set { _lastflyoffdate = value; }
            get { return _lastflyoffdate; }
        }
        /// <summary>
        /// LastCabinCode
        /// </summary>
        public string LastCabinCode
        {
            set { _lastcabincode = value; }
            get { return _lastcabincode; }
        }
        /// <summary>
        /// LastStartPort
        /// </summary>
        public string LastStartPort
        {
            set { _laststartport = value; }
            get { return _laststartport; }
        }
        /// <summary>
        /// LastEndPort
        /// </summary>
        public string LastEndPort
        {
            set { _lastendport = value; }
            get { return _lastendport; }
        }
        /// <summary>
        /// FPIsNotPrint
        /// </summary>
        public Byte FPIsNotPrint
        {
            set { _fpisnotprint = value; }
            get { return _fpisnotprint; }
        }
        /// <summary>
        /// FPHasSended
        /// </summary>
        public Byte FPHasSended
        {
            set { _fphassended = value; }
            get { return _fphassended; }
        }
        /// <summary>
        /// FPQQPassengerId
        /// </summary>
        public Int32 FPQQPassengerId
        {
            set { _fpqqpassengerid = value; }
            get { return _fpqqpassengerid; }
        }
        /// <summary>
        /// FPSalerEtickets
        /// </summary>
        public string FPSalerEtickets
        {
            set { _fpsaleretickets = value; }
            get { return _fpsaleretickets; }
        }
        /// <summary>
        /// FPUsedCoupon
        /// </summary>
        public Decimal FPUsedCoupon
        {
            set { _fpusedcoupon = value; }
            get { return _fpusedcoupon; }
        }
        /// <summary>
        /// FPInsuranceType
        /// </summary>
        public Byte FPInsuranceType
        {
            set { _fpinsurancetype = value; }
            get { return _fpinsurancetype; }
        }
        /// <summary>
        /// FPYBarePrice
        /// </summary>
        public Decimal FPYBarePrice
        {
            set { _fpybareprice = value; }
            get { return _fpybareprice; }
        }
        /// <summary>
        /// FPZBarePrice
        /// </summary>
        public Decimal FPZBarePrice
        {
            set { _fpzbareprice = value; }
            get { return _fpzbareprice; }
        }
        /// <summary>
        /// FPRiskCode
        /// </summary>
        public string FPRiskCode
        {
            set { _fpriskcode = value; }
            get { return _fpriskcode; }
        }
        /// <summary>
        /// FPTcShouldRefundTicketFee
        /// </summary>
        public Decimal FPTcShouldRefundTicketFee
        {
            set { _fptcshouldrefundticketfee = value; }
            get { return _fptcshouldrefundticketfee; }
        }
        /// <summary>
        /// FPCustShouldPayRefundFee
        /// </summary>
        public Decimal FPCustShouldPayRefundFee
        {
            set { _fpcustshouldpayrefundfee = value; }
            get { return _fpcustshouldpayrefundfee; }
        }
        /// <summary>
        /// FPTcShouldRefundBuildFee
        /// </summary>
        public Decimal FPTcShouldRefundBuildFee
        {
            set { _fptcshouldrefundbuildfee = value; }
            get { return _fptcshouldrefundbuildfee; }
        }
        /// <summary>
        /// FPTcShouldRefundTaxFare
        /// </summary>
        public Decimal FPTcShouldRefundTaxFare
        {
            set { _fptcshouldrefundtaxfare = value; }
            get { return _fptcshouldrefundtaxfare; }
        }
        /// <summary>
        /// FPTcShouldRefundInsuranceFee
        /// </summary>
        public Decimal FPTcShouldRefundInsuranceFee
        {
            set { _fptcshouldrefundinsurancefee = value; }
            get { return _fptcshouldrefundinsurancefee; }
        }
        /// <summary>
        /// FPNewPNR
        /// </summary>
        public string FPNewPNR
        {
            set { _fpnewpnr = value; }
            get { return _fpnewpnr; }
        }
        /// <summary>
        /// FPSelfRealPay
        /// </summary>
        public Decimal FPSelfRealPay
        {
            set { _fpselfrealpay = value; }
            get { return _fpselfrealpay; }
        }
        /// <summary>
        /// FPSelfTradeDate
        /// </summary>
        public DateTime FPSelfTradeDate
        {
            set { _fpselftradedate = value; }
            get { return _fpselftradedate; }
        }
        /// <summary>
        /// FPSelfTradeNo
        /// </summary>
        public string FPSelfTradeNo
        {
            set { _fpselftradeno = value; }
            get { return _fpselftradeno; }
        }
        /// <summary>
        /// FPSelfPaymentType
        /// </summary>
        public string FPSelfPaymentType
        {
            set { _fpselfpaymenttype = value; }
            get { return _fpselfpaymenttype; }
        }
        /// <summary>
        /// FPSelfRefSTDId
        /// </summary>
        public Int32 FPSelfRefSTDId
        {
            set { _fpselfrefstdid = value; }
            get { return _fpselfrefstdid; }
        }
        /// <summary>
        /// FPClearCustomerTicketPrice
        /// </summary>
        public Decimal FPClearCustomerTicketPrice
        {
            set { _fpclearcustomerticketprice = value; }
            get { return _fpclearcustomerticketprice; }
        }
        /// <summary>
        /// FPCopCustomerTicketPrice
        /// </summary>
        public Decimal FPCopCustomerTicketPrice
        {
            set { _fpcopcustomerticketprice = value; }
            get { return _fpcopcustomerticketprice; }
        }
        /// <summary>
        /// FPCopAllInsurance
        /// </summary>
        public Decimal FPCopAllInsurance
        {
            set { _fpcopallinsurance = value; }
            get { return _fpcopallinsurance; }
        }
        /// <summary>
        /// FPCopPassengerId
        /// </summary>
        public string FPCopPassengerId
        {
            set { _fpcoppassengerid = value; }
            get { return _fpcoppassengerid; }
        }
        /// <summary>
        /// FPCETSysTicketPrice
        /// </summary>
        public Int32 FPCETSysTicketPrice
        {
            set { _fpcetsysticketprice = value; }
            get { return _fpcetsysticketprice; }
        }
        /// <summary>
        /// FPCETBuildFarePrice
        /// </summary>
        public Int32 FPCETBuildFarePrice
        {
            set { _fpcetbuildfareprice = value; }
            get { return _fpcetbuildfareprice; }
        }
        /// <summary>
        /// FPCETTaxFarePrice
        /// </summary>
        public Int32 FPCETTaxFarePrice
        {
            set { _fpcettaxfareprice = value; }
            get { return _fpcettaxfareprice; }
        }
        /// <summary>
        /// FPCBPTTotaltax
        /// </summary>
        public Int32 FPCBPTTotaltax
        {
            set { _fpcbpttotaltax = value; }
            get { return _fpcbpttotaltax; }
        }
        /// <summary>
        /// FPCBPTPayprice
        /// </summary>
        public Int32 FPCBPTPayprice
        {
            set { _fpcbptpayprice = value; }
            get { return _fpcbptpayprice; }
        }
        /// <summary>
        /// FPCBPTPolicy
        /// </summary>
        public Decimal FPCBPTPolicy
        {
            set { _fpcbptpolicy = value; }
            get { return _fpcbptpolicy; }
        }
        /// <summary>
        /// FPPubPassengerId
        /// </summary>
        public Int32 FPPubPassengerId
        {
            set { _fppubpassengerid = value; }
            get { return _fppubpassengerid; }
        }
        /// <summary>
        /// FPForeProfit
        /// </summary>
        public Decimal FPForeProfit
        {
            set { _fpforeprofit = value; }
            get { return _fpforeprofit; }
        }
        /// <summary>
        /// FPPlaneType
        /// </summary>
        public Int32 FPPlaneType
        {
            set { _fpplanetype = value; }
            get { return _fpplanetype; }
        }
        /// <summary>
        /// FPRefRouteInfoId
        /// </summary>
        public Int32 FPRefRouteInfoId
        {
            set { _fprefrouteinfoid = value; }
            get { return _fprefrouteinfoid; }
        }
        /// <summary>
        /// FPCreateDate
        /// </summary>
        public DateTime FPCreateDate
        {
            set { _fpcreatedate = value; }
            get { return _fpcreatedate; }
        }
        /// <summary>
        /// FPCraftType
        /// </summary>
        public string FPCraftType
        {
            set { _fpcrafttype = value; }
            get { return _fpcrafttype; }
        }
        /// <summary>
        /// FPRouteNo
        /// </summary>
        public Byte FPRouteNo
        {
            set { _fprouteno = value; }
            get { return _fprouteno; }
        }
        /// <summary>
        /// FPSysRawTicketPrice
        /// </summary>
        public Decimal FPSysRawTicketPrice
        {
            set { _fpsysrawticketprice = value; }
            get { return _fpsysrawticketprice; }
        }
        #endregion Property

        #region Get Insert SQL
        /// <summary>
        /// 获取将此实体插入数据库的SQL语句
        /// </summary>
        public static string GetInsertSQL()
        {
            string sql = "Insert Into FlightPassenger (OrderId,OrderType,TicketType,SegmentType,FlyOffDate,ArrivalDate,StartPort,EndPort,Airways,FlightNO,CabinCode,PassengerType,CountryCode,PassengerName,CarrierName,CertType,CertNO,Gender,SysTicketPrice,AgreementTicketPrice,CustomerTicketPrice,BuildFarePrice,TaxFarePrice,InsuranceUnitPrice,THInsuranceCost,InsuranceGain,InsuranceFlag,InsurancePolicyNO,InsuranceNum,InsuranceReNum,InsurancePrice,ETicketNO,TicketPNR,THPrize,TicketFlag,THReceiptNO,IsTHPrint,MerchantReceiptNO,IsMerchantPrint,Remark,DisRate,BaseCabinCode,EquipmentDes,OutTicketDate,InputGain,RemoteBuyKeepRebate,RemoteBuyKeepPrice,BillFlag,OrderSerialid,BuyerPaymentRebate,BuyerPaymentFee,SalerPaymentRebate,SalerPaymentFee,PlatformPaymentServiceRebate,PlatformPaymentServiceFee,PlatformCollectSlottingRebate,PlatformCollectSlottingFee,PlatformReCollectSlottingFee,RemoteBuyPaymentSlottingFee,RemoteBuyRePaymentSlottingFee,BuyerRePaymentFee,SalerRePaymentFee,PriceRebate,DPPrize,TCKeapRebate,TCGain,IsChangePNR,IsETicketUsed,OrgSysPrice,PatSysPrice,NewSysPrice,Guid,CheckedFlag,BigCode,TripFee,UpgradeSerialId,IsSettlementUnionPrize,BirthDay,IsChanged,LastFlyOffDate,LastCabinCode,LastStartPort,LastEndPort,FPIsNotPrint,FPHasSended,FPQQPassengerId,FPSalerEtickets,FPUsedCoupon,FPInsuranceType,FPYBarePrice,FPZBarePrice,FPRiskCode,FPTcShouldRefundTicketFee,FPCustShouldPayRefundFee,FPTcShouldRefundBuildFee,FPTcShouldRefundTaxFare,FPTcShouldRefundInsuranceFee,FPNewPNR,FPSelfRealPay,FPSelfTradeDate,FPSelfTradeNo,FPSelfPaymentType,FPSelfRefSTDId,FPClearCustomerTicketPrice,FPCopCustomerTicketPrice,FPCopAllInsurance,FPCopPassengerId,FPCETSysTicketPrice,FPCETBuildFarePrice,FPCETTaxFarePrice,FPCBPTTotaltax,FPCBPTPayprice,FPCBPTPolicy,FPPubPassengerId,FPForeProfit,FPPlaneType,FPRefRouteInfoId,FPCreateDate,FPCraftType,FPRouteNo,FPSysRawTicketPrice)";
            sql += " values(@OrderId,@OrderType,@TicketType,@SegmentType,@FlyOffDate,@ArrivalDate,@StartPort,@EndPort,@Airways,@FlightNO,@CabinCode,@PassengerType,@CountryCode,@PassengerName,@CarrierName,@CertType,@CertNO,@Gender,@SysTicketPrice,@AgreementTicketPrice,@CustomerTicketPrice,@BuildFarePrice,@TaxFarePrice,@InsuranceUnitPrice,@THInsuranceCost,@InsuranceGain,@InsuranceFlag,@InsurancePolicyNO,@InsuranceNum,@InsuranceReNum,@InsurancePrice,@ETicketNO,@TicketPNR,@THPrize,@TicketFlag,@THReceiptNO,@IsTHPrint,@MerchantReceiptNO,@IsMerchantPrint,@Remark,@DisRate,@BaseCabinCode,@EquipmentDes,@OutTicketDate,@InputGain,@RemoteBuyKeepRebate,@RemoteBuyKeepPrice,@BillFlag,@OrderSerialid,@BuyerPaymentRebate,@BuyerPaymentFee,@SalerPaymentRebate,@SalerPaymentFee,@PlatformPaymentServiceRebate,@PlatformPaymentServiceFee,@PlatformCollectSlottingRebate,@PlatformCollectSlottingFee,@PlatformReCollectSlottingFee,@RemoteBuyPaymentSlottingFee,@RemoteBuyRePaymentSlottingFee,@BuyerRePaymentFee,@SalerRePaymentFee,@PriceRebate,@DPPrize,@TCKeapRebate,@TCGain,@IsChangePNR,@IsETicketUsed,@OrgSysPrice,@PatSysPrice,@NewSysPrice,@Guid,@CheckedFlag,@BigCode,@TripFee,@UpgradeSerialId,@IsSettlementUnionPrize,@BirthDay,@IsChanged,@LastFlyOffDate,@LastCabinCode,@LastStartPort,@LastEndPort,@FPIsNotPrint,@FPHasSended,@FPQQPassengerId,@FPSalerEtickets,@FPUsedCoupon,@FPInsuranceType,@FPYBarePrice,@FPZBarePrice,@FPRiskCode,@FPTcShouldRefundTicketFee,@FPCustShouldPayRefundFee,@FPTcShouldRefundBuildFee,@FPTcShouldRefundTaxFare,@FPTcShouldRefundInsuranceFee,@FPNewPNR,@FPSelfRealPay,@FPSelfTradeDate,@FPSelfTradeNo,@FPSelfPaymentType,@FPSelfRefSTDId,@FPClearCustomerTicketPrice,@FPCopCustomerTicketPrice,@FPCopAllInsurance,@FPCopPassengerId,@FPCETSysTicketPrice,@FPCETBuildFarePrice,@FPCETTaxFarePrice,@FPCBPTTotaltax,@FPCBPTPayprice,@FPCBPTPolicy,@FPPubPassengerId,@FPForeProfit,@FPPlaneType,@FPRefRouteInfoId,@FPCreateDate,@FPCraftType,@FPRouteNo,@FPSysRawTicketPrice)";
            return sql;
        }
        #endregion Get Insert SQL

        #region Get Select SQL
        /// <summary>
        /// 获取此实体查询数据库的SQL语句
        /// </summary>
        public static string GetSelectSQL()
        {
            string sql = "select Id , OrderId,OrderType,TicketType,SegmentType,FlyOffDate,ArrivalDate,StartPort,EndPort,Airways,FlightNO,CabinCode,PassengerType,CountryCode,PassengerName,CarrierName,CertType,CertNO,Gender,SysTicketPrice,AgreementTicketPrice,CustomerTicketPrice,BuildFarePrice,TaxFarePrice,InsuranceUnitPrice,THInsuranceCost,InsuranceGain,InsuranceFlag,InsurancePolicyNO,InsuranceNum,InsuranceReNum,InsurancePrice,ETicketNO,TicketPNR,THPrize,TicketFlag,THReceiptNO,IsTHPrint,MerchantReceiptNO,IsMerchantPrint,Remark,DisRate,BaseCabinCode,EquipmentDes,OutTicketDate,InputGain,RemoteBuyKeepRebate,RemoteBuyKeepPrice,BillFlag,OrderSerialid,BuyerPaymentRebate,BuyerPaymentFee,SalerPaymentRebate,SalerPaymentFee,PlatformPaymentServiceRebate,PlatformPaymentServiceFee,PlatformCollectSlottingRebate,PlatformCollectSlottingFee,PlatformReCollectSlottingFee,RemoteBuyPaymentSlottingFee,RemoteBuyRePaymentSlottingFee,BuyerRePaymentFee,SalerRePaymentFee,PriceRebate,DPPrize,TCKeapRebate,TCGain,IsChangePNR,IsETicketUsed,OrgSysPrice,PatSysPrice,NewSysPrice,Guid,CheckedFlag,BigCode,TripFee,UpgradeSerialId,IsSettlementUnionPrize,BirthDay,IsChanged,LastFlyOffDate,LastCabinCode,LastStartPort,LastEndPort,FPIsNotPrint,FPHasSended,FPQQPassengerId,FPSalerEtickets,FPUsedCoupon,FPInsuranceType,FPYBarePrice,FPZBarePrice,FPRiskCode,FPTcShouldRefundTicketFee,FPCustShouldPayRefundFee,FPTcShouldRefundBuildFee,FPTcShouldRefundTaxFare,FPTcShouldRefundInsuranceFee,FPNewPNR,FPSelfRealPay,FPSelfTradeDate,FPSelfTradeNo,FPSelfPaymentType,FPSelfRefSTDId,FPClearCustomerTicketPrice,FPCopCustomerTicketPrice,FPCopAllInsurance,FPCopPassengerId,FPCETSysTicketPrice,FPCETBuildFarePrice,FPCETTaxFarePrice,FPCBPTTotaltax,FPCBPTPayprice,FPCBPTPolicy,FPPubPassengerId,FPForeProfit,FPPlaneType,FPRefRouteInfoId,FPCreateDate,FPCraftType,FPRouteNo,FPSysRawTicketPrice from FlightPassenger with(nolock) where 1 = 1 ";
            return sql;
        }
        #endregion Get Select SQL

        #region Get Update SQL
        /// <summary>
        /// 获取此实体更新数据库的SQL语句
        /// </summary>
        public static string GetUpdateSQL()
        {
            string sql = @"update FlightPassenger
			set
			OrderId = @OrderId,
			OrderType = @OrderType,
			TicketType = @TicketType,
			SegmentType = @SegmentType,
			FlyOffDate = @FlyOffDate,
			ArrivalDate = @ArrivalDate,
			StartPort = @StartPort,
			EndPort = @EndPort,
			Airways = @Airways,
			FlightNO = @FlightNO,
			CabinCode = @CabinCode,
			PassengerType = @PassengerType,
			CountryCode = @CountryCode,
			PassengerName = @PassengerName,
			CarrierName = @CarrierName,
			CertType = @CertType,
			CertNO = @CertNO,
			Gender = @Gender,
			SysTicketPrice = @SysTicketPrice,
			AgreementTicketPrice = @AgreementTicketPrice,
			CustomerTicketPrice = @CustomerTicketPrice,
			BuildFarePrice = @BuildFarePrice,
			TaxFarePrice = @TaxFarePrice,
			InsuranceUnitPrice = @InsuranceUnitPrice,
			THInsuranceCost = @THInsuranceCost,
			InsuranceGain = @InsuranceGain,
			InsuranceFlag = @InsuranceFlag,
			InsurancePolicyNO = @InsurancePolicyNO,
			InsuranceNum = @InsuranceNum,
			InsuranceReNum = @InsuranceReNum,
			InsurancePrice = @InsurancePrice,
			ETicketNO = @ETicketNO,
			TicketPNR = @TicketPNR,
			THPrize = @THPrize,
			TicketFlag = @TicketFlag,
			THReceiptNO = @THReceiptNO,
			IsTHPrint = @IsTHPrint,
			MerchantReceiptNO = @MerchantReceiptNO,
			IsMerchantPrint = @IsMerchantPrint,
			Remark = @Remark,
			DisRate = @DisRate,
			BaseCabinCode = @BaseCabinCode,
			EquipmentDes = @EquipmentDes,
			OutTicketDate = @OutTicketDate,
			InputGain = @InputGain,
			RemoteBuyKeepRebate = @RemoteBuyKeepRebate,
			RemoteBuyKeepPrice = @RemoteBuyKeepPrice,
			BillFlag = @BillFlag,
			OrderSerialid = @OrderSerialid,
			BuyerPaymentRebate = @BuyerPaymentRebate,
			BuyerPaymentFee = @BuyerPaymentFee,
			SalerPaymentRebate = @SalerPaymentRebate,
			SalerPaymentFee = @SalerPaymentFee,
			PlatformPaymentServiceRebate = @PlatformPaymentServiceRebate,
			PlatformPaymentServiceFee = @PlatformPaymentServiceFee,
			PlatformCollectSlottingRebate = @PlatformCollectSlottingRebate,
			PlatformCollectSlottingFee = @PlatformCollectSlottingFee,
			PlatformReCollectSlottingFee = @PlatformReCollectSlottingFee,
			RemoteBuyPaymentSlottingFee = @RemoteBuyPaymentSlottingFee,
			RemoteBuyRePaymentSlottingFee = @RemoteBuyRePaymentSlottingFee,
			BuyerRePaymentFee = @BuyerRePaymentFee,
			SalerRePaymentFee = @SalerRePaymentFee,
			PriceRebate = @PriceRebate,
			DPPrize = @DPPrize,
			TCKeapRebate = @TCKeapRebate,
			TCGain = @TCGain,
			IsChangePNR = @IsChangePNR,
			IsETicketUsed = @IsETicketUsed,
			OrgSysPrice = @OrgSysPrice,
			PatSysPrice = @PatSysPrice,
			NewSysPrice = @NewSysPrice,
			Guid = @Guid,
			CheckedFlag = @CheckedFlag,
			BigCode = @BigCode,
			TripFee = @TripFee,
			UpgradeSerialId = @UpgradeSerialId,
			IsSettlementUnionPrize = @IsSettlementUnionPrize,
			BirthDay = @BirthDay,
			IsChanged = @IsChanged,
			LastFlyOffDate = @LastFlyOffDate,
			LastCabinCode = @LastCabinCode,
			LastStartPort = @LastStartPort,
			LastEndPort = @LastEndPort,
			FPIsNotPrint = @FPIsNotPrint,
			FPHasSended = @FPHasSended,
			FPQQPassengerId = @FPQQPassengerId,
			FPSalerEtickets = @FPSalerEtickets,
			FPUsedCoupon = @FPUsedCoupon,
			FPInsuranceType = @FPInsuranceType,
			FPYBarePrice = @FPYBarePrice,
			FPZBarePrice = @FPZBarePrice,
			FPRiskCode = @FPRiskCode,
			FPTcShouldRefundTicketFee = @FPTcShouldRefundTicketFee,
			FPCustShouldPayRefundFee = @FPCustShouldPayRefundFee,
			FPTcShouldRefundBuildFee = @FPTcShouldRefundBuildFee,
			FPTcShouldRefundTaxFare = @FPTcShouldRefundTaxFare,
			FPTcShouldRefundInsuranceFee = @FPTcShouldRefundInsuranceFee,
			FPNewPNR = @FPNewPNR,
			FPSelfRealPay = @FPSelfRealPay,
			FPSelfTradeDate = @FPSelfTradeDate,
			FPSelfTradeNo = @FPSelfTradeNo,
			FPSelfPaymentType = @FPSelfPaymentType,
			FPSelfRefSTDId = @FPSelfRefSTDId,
			FPClearCustomerTicketPrice = @FPClearCustomerTicketPrice,
			FPCopCustomerTicketPrice = @FPCopCustomerTicketPrice,
			FPCopAllInsurance = @FPCopAllInsurance,
			FPCopPassengerId = @FPCopPassengerId,
			FPCETSysTicketPrice = @FPCETSysTicketPrice,
			FPCETBuildFarePrice = @FPCETBuildFarePrice,
			FPCETTaxFarePrice = @FPCETTaxFarePrice,
			FPCBPTTotaltax = @FPCBPTTotaltax,
			FPCBPTPayprice = @FPCBPTPayprice,
			FPCBPTPolicy = @FPCBPTPolicy,
			FPPubPassengerId = @FPPubPassengerId,
			FPForeProfit = @FPForeProfit,
			FPPlaneType = @FPPlaneType,
			FPRefRouteInfoId = @FPRefRouteInfoId,
			FPCreateDate = @FPCreateDate,
			FPCraftType = @FPCraftType,
			FPRouteNo = @FPRouteNo,
			FPSysRawTicketPrice = @FPSysRawTicketPrice
			where Id = @Id ";
            return sql;
        }
        #endregion Get Update SQL

        #region Get Delete SQL
        /// <summary>
        /// 获取删除此实体的SQL语句
        /// </summary>
        public static string GetDeleteSQL()
        {
            string sql = @"delete from FlightPassenger
			where Id = @Id ";
            return sql;
        }
        #endregion Get Delete SQL

        #region Get Insert SqlParameter
        /// <summary>
        /// 获取将此实体插入数据库的SqlParameter参数
        /// </summary>
        public SqlParameter[] ToSqlParameters()
        {
            List<SqlParameter> paramList = new List<SqlParameter>();
            paramList.Add(new SqlParameter("@Id", Id));
            paramList.Add(new SqlParameter("@OrderId", OrderId));
            paramList.Add(new SqlParameter("@OrderType", OrderType));
            paramList.Add(new SqlParameter("@TicketType", TicketType));
            paramList.Add(new SqlParameter("@SegmentType", SegmentType));
            paramList.Add(new SqlParameter("@FlyOffDate", FlyOffDate));
            paramList.Add(new SqlParameter("@ArrivalDate", ArrivalDate));
            paramList.Add(new SqlParameter("@StartPort", StartPort));
            paramList.Add(new SqlParameter("@EndPort", EndPort));
            paramList.Add(new SqlParameter("@Airways", Airways));
            paramList.Add(new SqlParameter("@FlightNO", FlightNO));
            paramList.Add(new SqlParameter("@CabinCode", CabinCode));
            paramList.Add(new SqlParameter("@PassengerType", PassengerType));
            paramList.Add(new SqlParameter("@CountryCode", CountryCode));
            paramList.Add(new SqlParameter("@PassengerName", PassengerName));
            paramList.Add(new SqlParameter("@CarrierName", CarrierName));
            paramList.Add(new SqlParameter("@CertType", CertType));
            paramList.Add(new SqlParameter("@CertNO", CertNO));
            paramList.Add(new SqlParameter("@Gender", Gender));
            paramList.Add(new SqlParameter("@SysTicketPrice", SysTicketPrice));
            paramList.Add(new SqlParameter("@AgreementTicketPrice", AgreementTicketPrice));
            paramList.Add(new SqlParameter("@CustomerTicketPrice", CustomerTicketPrice));
            paramList.Add(new SqlParameter("@BuildFarePrice", BuildFarePrice));
            paramList.Add(new SqlParameter("@TaxFarePrice", TaxFarePrice));
            paramList.Add(new SqlParameter("@InsuranceUnitPrice", InsuranceUnitPrice));
            paramList.Add(new SqlParameter("@THInsuranceCost", THInsuranceCost));
            paramList.Add(new SqlParameter("@InsuranceGain", InsuranceGain));
            paramList.Add(new SqlParameter("@InsuranceFlag", InsuranceFlag));
            paramList.Add(new SqlParameter("@InsurancePolicyNO", InsurancePolicyNO));
            paramList.Add(new SqlParameter("@InsuranceNum", InsuranceNum));
            paramList.Add(new SqlParameter("@InsuranceReNum", InsuranceReNum));
            paramList.Add(new SqlParameter("@InsurancePrice", InsurancePrice));
            paramList.Add(new SqlParameter("@ETicketNO", ETicketNO));
            paramList.Add(new SqlParameter("@TicketPNR", TicketPNR));
            paramList.Add(new SqlParameter("@THPrize", THPrize));
            paramList.Add(new SqlParameter("@TicketFlag", TicketFlag));
            paramList.Add(new SqlParameter("@THReceiptNO", THReceiptNO));
            paramList.Add(new SqlParameter("@IsTHPrint", IsTHPrint));
            paramList.Add(new SqlParameter("@MerchantReceiptNO", MerchantReceiptNO));
            paramList.Add(new SqlParameter("@IsMerchantPrint", IsMerchantPrint));
            paramList.Add(new SqlParameter("@Remark", Remark));
            paramList.Add(new SqlParameter("@DisRate", DisRate));
            paramList.Add(new SqlParameter("@BaseCabinCode", BaseCabinCode));
            paramList.Add(new SqlParameter("@EquipmentDes", EquipmentDes));
            paramList.Add(new SqlParameter("@OutTicketDate", OutTicketDate));
            paramList.Add(new SqlParameter("@InputGain", InputGain));
            paramList.Add(new SqlParameter("@RemoteBuyKeepRebate", RemoteBuyKeepRebate));
            paramList.Add(new SqlParameter("@RemoteBuyKeepPrice", RemoteBuyKeepPrice));
            paramList.Add(new SqlParameter("@BillFlag", BillFlag));
            paramList.Add(new SqlParameter("@OrderSerialid", OrderSerialid));
            paramList.Add(new SqlParameter("@BuyerPaymentRebate", BuyerPaymentRebate));
            paramList.Add(new SqlParameter("@BuyerPaymentFee", BuyerPaymentFee));
            paramList.Add(new SqlParameter("@SalerPaymentRebate", SalerPaymentRebate));
            paramList.Add(new SqlParameter("@SalerPaymentFee", SalerPaymentFee));
            paramList.Add(new SqlParameter("@PlatformPaymentServiceRebate", PlatformPaymentServiceRebate));
            paramList.Add(new SqlParameter("@PlatformPaymentServiceFee", PlatformPaymentServiceFee));
            paramList.Add(new SqlParameter("@PlatformCollectSlottingRebate", PlatformCollectSlottingRebate));
            paramList.Add(new SqlParameter("@PlatformCollectSlottingFee", PlatformCollectSlottingFee));
            paramList.Add(new SqlParameter("@PlatformReCollectSlottingFee", PlatformReCollectSlottingFee));
            paramList.Add(new SqlParameter("@RemoteBuyPaymentSlottingFee", RemoteBuyPaymentSlottingFee));
            paramList.Add(new SqlParameter("@RemoteBuyRePaymentSlottingFee", RemoteBuyRePaymentSlottingFee));
            paramList.Add(new SqlParameter("@BuyerRePaymentFee", BuyerRePaymentFee));
            paramList.Add(new SqlParameter("@SalerRePaymentFee", SalerRePaymentFee));
            paramList.Add(new SqlParameter("@PriceRebate", PriceRebate));
            paramList.Add(new SqlParameter("@DPPrize", DPPrize));
            paramList.Add(new SqlParameter("@TCKeapRebate", TCKeapRebate));
            paramList.Add(new SqlParameter("@TCGain", TCGain));
            paramList.Add(new SqlParameter("@IsChangePNR", IsChangePNR));
            paramList.Add(new SqlParameter("@IsETicketUsed", IsETicketUsed));
            paramList.Add(new SqlParameter("@OrgSysPrice", OrgSysPrice));
            paramList.Add(new SqlParameter("@PatSysPrice", PatSysPrice));
            paramList.Add(new SqlParameter("@NewSysPrice", NewSysPrice));
            paramList.Add(new SqlParameter("@Guid", Guid));
            paramList.Add(new SqlParameter("@CheckedFlag", CheckedFlag));
            paramList.Add(new SqlParameter("@BigCode", BigCode));
            paramList.Add(new SqlParameter("@TripFee", TripFee));
            paramList.Add(new SqlParameter("@UpgradeSerialId", UpgradeSerialId));
            paramList.Add(new SqlParameter("@IsSettlementUnionPrize", IsSettlementUnionPrize));
            paramList.Add(new SqlParameter("@BirthDay", BirthDay));
            paramList.Add(new SqlParameter("@IsChanged", IsChanged));
            paramList.Add(new SqlParameter("@LastFlyOffDate", LastFlyOffDate));
            paramList.Add(new SqlParameter("@LastCabinCode", LastCabinCode));
            paramList.Add(new SqlParameter("@LastStartPort", LastStartPort));
            paramList.Add(new SqlParameter("@LastEndPort", LastEndPort));
            paramList.Add(new SqlParameter("@FPIsNotPrint", FPIsNotPrint));
            paramList.Add(new SqlParameter("@FPHasSended", FPHasSended));
            paramList.Add(new SqlParameter("@FPQQPassengerId", FPQQPassengerId));
            paramList.Add(new SqlParameter("@FPSalerEtickets", FPSalerEtickets));
            paramList.Add(new SqlParameter("@FPUsedCoupon", FPUsedCoupon));
            paramList.Add(new SqlParameter("@FPInsuranceType", FPInsuranceType));
            paramList.Add(new SqlParameter("@FPYBarePrice", FPYBarePrice));
            paramList.Add(new SqlParameter("@FPZBarePrice", FPZBarePrice));
            paramList.Add(new SqlParameter("@FPRiskCode", FPRiskCode));
            paramList.Add(new SqlParameter("@FPTcShouldRefundTicketFee", FPTcShouldRefundTicketFee));
            paramList.Add(new SqlParameter("@FPCustShouldPayRefundFee", FPCustShouldPayRefundFee));
            paramList.Add(new SqlParameter("@FPTcShouldRefundBuildFee", FPTcShouldRefundBuildFee));
            paramList.Add(new SqlParameter("@FPTcShouldRefundTaxFare", FPTcShouldRefundTaxFare));
            paramList.Add(new SqlParameter("@FPTcShouldRefundInsuranceFee", FPTcShouldRefundInsuranceFee));
            paramList.Add(new SqlParameter("@FPNewPNR", FPNewPNR));
            paramList.Add(new SqlParameter("@FPSelfRealPay", FPSelfRealPay));
            paramList.Add(new SqlParameter("@FPSelfTradeDate", FPSelfTradeDate));
            paramList.Add(new SqlParameter("@FPSelfTradeNo", FPSelfTradeNo));
            paramList.Add(new SqlParameter("@FPSelfPaymentType", FPSelfPaymentType));
            paramList.Add(new SqlParameter("@FPSelfRefSTDId", FPSelfRefSTDId));
            paramList.Add(new SqlParameter("@FPClearCustomerTicketPrice", FPClearCustomerTicketPrice));
            paramList.Add(new SqlParameter("@FPCopCustomerTicketPrice", FPCopCustomerTicketPrice));
            paramList.Add(new SqlParameter("@FPCopAllInsurance", FPCopAllInsurance));
            paramList.Add(new SqlParameter("@FPCopPassengerId", FPCopPassengerId));
            paramList.Add(new SqlParameter("@FPCETSysTicketPrice", FPCETSysTicketPrice));
            paramList.Add(new SqlParameter("@FPCETBuildFarePrice", FPCETBuildFarePrice));
            paramList.Add(new SqlParameter("@FPCETTaxFarePrice", FPCETTaxFarePrice));
            paramList.Add(new SqlParameter("@FPCBPTTotaltax", FPCBPTTotaltax));
            paramList.Add(new SqlParameter("@FPCBPTPayprice", FPCBPTPayprice));
            paramList.Add(new SqlParameter("@FPCBPTPolicy", FPCBPTPolicy));
            paramList.Add(new SqlParameter("@FPPubPassengerId", FPPubPassengerId));
            paramList.Add(new SqlParameter("@FPForeProfit", FPForeProfit));
            paramList.Add(new SqlParameter("@FPPlaneType", FPPlaneType));
            paramList.Add(new SqlParameter("@FPRefRouteInfoId", FPRefRouteInfoId));
            paramList.Add(new SqlParameter("@FPCreateDate", FPCreateDate));
            paramList.Add(new SqlParameter("@FPCraftType", FPCraftType));
            paramList.Add(new SqlParameter("@FPRouteNo", FPRouteNo));
            paramList.Add(new SqlParameter("@FPSysRawTicketPrice", FPSysRawTicketPrice));
            return paramList.ToArray();
        }
        #endregion Get Insert SqlParameter

    }
}

